<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>DataAccessUtility xref</title>
<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../../apidocs/com/katesoft/scale4j/persistent/utils/DataAccessUtility.html">View Javadoc</a></div><pre>

<a class="jxr_linenumber" name="1" href="#1">1</a>   <strong class="jxr_keyword">package</strong> com.katesoft.scale4j.persistent.utils;
<a class="jxr_linenumber" name="2" href="#2">2</a>   
<a class="jxr_linenumber" name="3" href="#3">3</a>   <strong class="jxr_keyword">import</strong> com.katesoft.scale4j.log.Logger;
<a class="jxr_linenumber" name="4" href="#4">4</a>   <strong class="jxr_keyword">import</strong> com.katesoft.scale4j.log.LogFactory;
<a class="jxr_linenumber" name="5" href="#5">5</a>   <strong class="jxr_keyword">import</strong> com.katesoft.scale4j.persistent.model.unified.AbstractPersistentEntity;
<a class="jxr_linenumber" name="6" href="#6">6</a>   <strong class="jxr_keyword">import</strong> com.katesoft.scale4j.persistent.model.unified.IBO;
<a class="jxr_linenumber" name="7" href="#7">7</a>   <strong class="jxr_keyword">import</strong> org.hibernate.envers.AuditReader;
<a class="jxr_linenumber" name="8" href="#8">8</a>   <strong class="jxr_keyword">import</strong> org.hibernate.envers.RevisionType;
<a class="jxr_linenumber" name="9" href="#9">9</a>   <strong class="jxr_keyword">import</strong> org.hibernate.envers.query.AuditEntity;
<a class="jxr_linenumber" name="10" href="#10">10</a>  
<a class="jxr_linenumber" name="11" href="#11">11</a>  <strong class="jxr_keyword">import</strong> java.sql.Connection;
<a class="jxr_linenumber" name="12" href="#12">12</a>  <strong class="jxr_keyword">import</strong> java.sql.ResultSet;
<a class="jxr_linenumber" name="13" href="#13">13</a>  <strong class="jxr_keyword">import</strong> java.sql.SQLException;
<a class="jxr_linenumber" name="14" href="#14">14</a>  <strong class="jxr_keyword">import</strong> java.util.Collection;
<a class="jxr_linenumber" name="15" href="#15">15</a>  <strong class="jxr_keyword">import</strong> java.util.Iterator;
<a class="jxr_linenumber" name="16" href="#16">16</a>  
<a class="jxr_linenumber" name="17" href="#17">17</a>  <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="18" href="#18">18</a>  <em class="jxr_javadoccomment"> * This is utility class, that some useful method for handling jdbc stuff.</em>
<a class="jxr_linenumber" name="19" href="#19">19</a>  <em class="jxr_javadoccomment"> *</em>
<a class="jxr_linenumber" name="20" href="#20">20</a>  <em class="jxr_javadoccomment"> * @author kate2007</em>
<a class="jxr_linenumber" name="21" href="#21">21</a>  <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="22" href="#22">22</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../com/katesoft/scale4j/persistent/utils/DataAccessUtility.html">DataAccessUtility</a>
<a class="jxr_linenumber" name="23" href="#23">23</a>  {
<a class="jxr_linenumber" name="24" href="#24">24</a>      <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <a href="../../../../../com/katesoft/scale4j/log/Logger.html">Logger</a> LOGGER = LogFactory.getLogger(DataAccessUtility.<strong class="jxr_keyword">class</strong>);
<a class="jxr_linenumber" name="25" href="#25">25</a>  
<a class="jxr_linenumber" name="26" href="#26">26</a>      <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="27" href="#27">27</a>  <em class="jxr_javadoccomment">     * @param &lt;T&gt;  element type, must extends {@link AbstractPersistentEntity}.</em>
<a class="jxr_linenumber" name="28" href="#28">28</a>  <em class="jxr_javadoccomment">     * @param list target collection.</em>
<a class="jxr_linenumber" name="29" href="#29">29</a>  <em class="jxr_javadoccomment">     * @return the first(random) element of collection if available, else returns &lt;code&gt;null&lt;/code&gt;.</em>
<a class="jxr_linenumber" name="30" href="#30">30</a>  <em class="jxr_javadoccomment">     */</em>
<a class="jxr_linenumber" name="31" href="#31">31</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> &lt;T <strong class="jxr_keyword">extends</strong> AbstractPersistentEntity&gt; T fetchFirstRowOrNull(<strong class="jxr_keyword">final</strong> Collection&lt;T&gt; list)
<a class="jxr_linenumber" name="32" href="#32">32</a>      {
<a class="jxr_linenumber" name="33" href="#33">33</a>          <strong class="jxr_keyword">final</strong> Iterator&lt;T&gt; iterator = list.iterator();
<a class="jxr_linenumber" name="34" href="#34">34</a>          <strong class="jxr_keyword">if</strong> (iterator.hasNext()) { <strong class="jxr_keyword">return</strong> iterator.next(); }
<a class="jxr_linenumber" name="35" href="#35">35</a>          <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="36" href="#36">36</a>      }
<a class="jxr_linenumber" name="37" href="#37">37</a>  
<a class="jxr_linenumber" name="38" href="#38">38</a>      <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="39" href="#39">39</a>  <em class="jxr_javadoccomment">     * check if all tables from given array/collection exist in database.</em>
<a class="jxr_linenumber" name="40" href="#40">40</a>  <em class="jxr_javadoccomment">     *</em>
<a class="jxr_linenumber" name="41" href="#41">41</a>  <em class="jxr_javadoccomment">     * @param connection actual jdbc connection</em>
<a class="jxr_linenumber" name="42" href="#42">42</a>  <em class="jxr_javadoccomment">     * @param tables     array of tables</em>
<a class="jxr_linenumber" name="43" href="#43">43</a>  <em class="jxr_javadoccomment">     * @return true if all tables from given collection exist.</em>
<a class="jxr_linenumber" name="44" href="#44">44</a>  <em class="jxr_javadoccomment">     * @throws java.sql.SQLException if JDBC exception occurred</em>
<a class="jxr_linenumber" name="45" href="#45">45</a>  <em class="jxr_javadoccomment">     */</em>
<a class="jxr_linenumber" name="46" href="#46">46</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">boolean</strong> allTablesExist(Connection connection,
<a class="jxr_linenumber" name="47" href="#47">47</a>                                           String[] tables) <strong class="jxr_keyword">throws</strong> SQLException
<a class="jxr_linenumber" name="48" href="#48">48</a>      {
<a class="jxr_linenumber" name="49" href="#49">49</a>          <strong class="jxr_keyword">boolean</strong> tablesCreated = <strong class="jxr_keyword">true</strong>;
<a class="jxr_linenumber" name="50" href="#50">50</a>          <strong class="jxr_keyword">for</strong> (String table : tables) {
<a class="jxr_linenumber" name="51" href="#51">51</a>              ResultSet resultSet = connection.getMetaData().getTables(connection.getCatalog(), <strong class="jxr_keyword">null</strong>, table, <strong class="jxr_keyword">null</strong>);
<a class="jxr_linenumber" name="52" href="#52">52</a>              <strong class="jxr_keyword">if</strong> (!resultSet.next()) {
<a class="jxr_linenumber" name="53" href="#53">53</a>                  tablesCreated = false;
<a class="jxr_linenumber" name="54" href="#54">54</a>                  LOGGER.debug(<span class="jxr_string">"table %s does not exist"</span>, table);
<a class="jxr_linenumber" name="55" href="#55">55</a>              }
<a class="jxr_linenumber" name="56" href="#56">56</a>              <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="57" href="#57">57</a>                  LOGGER.debug(<span class="jxr_string">"table %s already exists"</span>, table);
<a class="jxr_linenumber" name="58" href="#58">58</a>              }
<a class="jxr_linenumber" name="59" href="#59">59</a>          }
<a class="jxr_linenumber" name="60" href="#60">60</a>          LOGGER.debug(<span class="jxr_string">"tablesCreated(connection=&gt;%s,tables=&gt;%s):=%s]"</span>, connection, tables, tablesCreated);
<a class="jxr_linenumber" name="61" href="#61">61</a>          <strong class="jxr_keyword">return</strong> tablesCreated;
<a class="jxr_linenumber" name="62" href="#62">62</a>      }
<a class="jxr_linenumber" name="63" href="#63">63</a>  
<a class="jxr_linenumber" name="64" href="#64">64</a>      <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="65" href="#65">65</a>  <em class="jxr_javadoccomment">     * looking for initial revision of entity(for first database insert).</em>
<a class="jxr_linenumber" name="66" href="#66">66</a>  <em class="jxr_javadoccomment">     *</em>
<a class="jxr_linenumber" name="67" href="#67">67</a>  <em class="jxr_javadoccomment">     * @param auditReader      envers reader implementation</em>
<a class="jxr_linenumber" name="68" href="#68">68</a>  <em class="jxr_javadoccomment">     * @param persistentClass  something that extends {@link AbstractPersistentEntity}</em>
<a class="jxr_linenumber" name="69" href="#69">69</a>  <em class="jxr_javadoccomment">     * @param uniqueIdentifier primary key of entity</em>
<a class="jxr_linenumber" name="70" href="#70">70</a>  <em class="jxr_javadoccomment">     * @return revision number</em>
<a class="jxr_linenumber" name="71" href="#71">71</a>  <em class="jxr_javadoccomment">     */</em>
<a class="jxr_linenumber" name="72" href="#72">72</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> Number initialRevision(AuditReader auditReader,
<a class="jxr_linenumber" name="73" href="#73">73</a>                                           Class&lt;? <strong class="jxr_keyword">extends</strong> IBO&gt; persistentClass,
<a class="jxr_linenumber" name="74" href="#74">74</a>                                           <strong class="jxr_keyword">long</strong> uniqueIdentifier)
<a class="jxr_linenumber" name="75" href="#75">75</a>      {
<a class="jxr_linenumber" name="76" href="#76">76</a>          <strong class="jxr_keyword">return</strong> (Number) auditReader.createQuery().
<a class="jxr_linenumber" name="77" href="#77">77</a>              forRevisionsOfEntity(persistentClass, <strong class="jxr_keyword">true</strong>, <strong class="jxr_keyword">true</strong>).
<a class="jxr_linenumber" name="78" href="#78">78</a>              add(AuditEntity.id().eq(uniqueIdentifier)).
<a class="jxr_linenumber" name="79" href="#79">79</a>              add(AuditEntity.revisionType().eq(RevisionType.ADD)).
<a class="jxr_linenumber" name="80" href="#80">80</a>              addProjection(AuditEntity.revisionNumber().min()).getSingleResult();
<a class="jxr_linenumber" name="81" href="#81">81</a>      }
<a class="jxr_linenumber" name="82" href="#82">82</a>  
<a class="jxr_linenumber" name="83" href="#83">83</a>      <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="84" href="#84">84</a>  <em class="jxr_javadoccomment">     * looking for latest modify revision of entity(for latest database update/delete).</em>
<a class="jxr_linenumber" name="85" href="#85">85</a>  <em class="jxr_javadoccomment">     *</em>
<a class="jxr_linenumber" name="86" href="#86">86</a>  <em class="jxr_javadoccomment">     * @param auditReader      envers reader implementation</em>
<a class="jxr_linenumber" name="87" href="#87">87</a>  <em class="jxr_javadoccomment">     * @param persistentClass  something that extends {@link AbstractPersistentEntity}</em>
<a class="jxr_linenumber" name="88" href="#88">88</a>  <em class="jxr_javadoccomment">     * @param uniqueIdentifier primary key of entity</em>
<a class="jxr_linenumber" name="89" href="#89">89</a>  <em class="jxr_javadoccomment">     * @return revision number</em>
<a class="jxr_linenumber" name="90" href="#90">90</a>  <em class="jxr_javadoccomment">     */</em>
<a class="jxr_linenumber" name="91" href="#91">91</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> Number latestModifyRevision(AuditReader auditReader,
<a class="jxr_linenumber" name="92" href="#92">92</a>                                                Class&lt;? <strong class="jxr_keyword">extends</strong> IBO&gt; persistentClass,
<a class="jxr_linenumber" name="93" href="#93">93</a>                                                <strong class="jxr_keyword">long</strong> uniqueIdentifier)
<a class="jxr_linenumber" name="94" href="#94">94</a>      {
<a class="jxr_linenumber" name="95" href="#95">95</a>          <strong class="jxr_keyword">return</strong> (Number) auditReader.createQuery().
<a class="jxr_linenumber" name="96" href="#96">96</a>              forRevisionsOfEntity(persistentClass, <strong class="jxr_keyword">true</strong>, <strong class="jxr_keyword">true</strong>).
<a class="jxr_linenumber" name="97" href="#97">97</a>              add(AuditEntity.id().eq(uniqueIdentifier)).
<a class="jxr_linenumber" name="98" href="#98">98</a>              add(AuditEntity.revisionType().in(<strong class="jxr_keyword">new</strong> RevisionType[]{RevisionType.MOD, RevisionType.DEL})).
<a class="jxr_linenumber" name="99" href="#99">99</a>              addProjection(AuditEntity.revisionNumber().max()).getSingleResult();
<a class="jxr_linenumber" name="100" href="#100">100</a>     }
<a class="jxr_linenumber" name="101" href="#101">101</a> 
<a class="jxr_linenumber" name="102" href="#102">102</a>     <strong class="jxr_keyword">private</strong> <a href="../../../../../com/katesoft/scale4j/persistent/utils/DataAccessUtility.html">DataAccessUtility</a>() {}
<a class="jxr_linenumber" name="103" href="#103">103</a> }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

